MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

10 rows where Artist Alpha Sort = 19023

View and edit SQL

Suggested facets: Is Highlight, Department, Object Name, Object Date, Object Begin Date, Object End Date, Medium, Credit Line, Classification

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
210884 1999.391 0 1 338272 Drawings and Prints 11 Drawing 23 Decorated Initial with Scene of Christ Entering the Temple.           Artist 2   Lorenzo Monaco (Piero di Giovanni) Italian, Florence (?) ca. 1370–1425 Florence (?)   Lorenzo Monaco (Piero di Giovanni) 19023 Italian 6 1370 1425 1408–11 1408 1411 Pen and pale grayish brown ink, brush and pale grayish brown wash (figural scene), pen and pale brown ink, over construction in leadpoint, ruling and compass work (ornamental parts), ruled lines in red ink, notes and words in pen and dark brown ink (musical score), on vellum 31460 Overall: 12 x 9 5/8 in. (30.5 x 24.4 cm) Purchase, Lila Acheson Wallace Gift, 1999                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
306845 65.14.1 0 1 436911 European Paintings 15 Painting 69 Abraham           Artist 2   Lorenzo Monaco (Piero di Giovanni) Italian, Florence (?) ca. 1370–1425 Florence (?)   Lorenzo Monaco (Piero di Giovanni) 19023 Italian 6 1370 1425 ca. 1408–10 1408 1410 Tempera on wood, gold ground 44477 Overall 26 x 16 7/8 in. (66 x 42.9 cm); painted surface 22 7/8 x 16 5/8 in. (58.1 x 42.2 cm) Gwynne Andrews Fund, and Gift of G. Louise Robinson, by exchange, 1965                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
306846 65.14.4 0 1 436912 European Paintings 15 Painting 69 David           Artist 2   Lorenzo Monaco (Piero di Giovanni) Italian, Florence (?) ca. 1370–1425 Florence (?)   Lorenzo Monaco (Piero di Giovanni) 19023 Italian 6 1370 1425 ca. 1408–10 1408 1410 Tempera on wood, gold ground 44477 Arched top, 22 3/8 x 17 in. (56.8 x 43.2 cm) Gwynne Andrews and Marquand Funds, and Gift of Mrs. Ralph J. Hines, by exchange, 1965                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
306847 65.14.3 0 1 436913 European Paintings 15 Painting 69 Moses           Artist 2   Lorenzo Monaco (Piero di Giovanni) Italian, Florence (?) ca. 1370–1425 Florence (?)   Lorenzo Monaco (Piero di Giovanni) 19023 Italian 6 1370 1425 ca. 1408–10 1408 1410 Tempera on wood, gold ground 44477 Overall 24 1/2 x 17 1/2 in. (62.2 x 44.5 cm); painted surface 22 5/8 x 17 5/8 in. (57.5 x 44.8 cm) Gwynne Andrews Fund, and Bequest of Mabel Choate, in memory of her father, Joseph Hodges Choate, by exchange, 1965                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
306848 65.14.2 0 1 436914 European Paintings 15 Painting 69 Noah           Artist 2   Lorenzo Monaco (Piero di Giovanni) Italian, Florence (?) ca. 1370–1425 Florence (?)   Lorenzo Monaco (Piero di Giovanni) 19023 Italian 6 1370 1425 ca. 1408–10 1408 1410 Tempera on wood, gold ground 44477 Overall 25 7/8 x 17 3/8 in. (65.7 x 44.1 cm); painted surface 22 7/8 x 17 in. (58.1 x 43.2 cm) Gwynne Andrews Fund, and Gift of Paul Peralta Ramos, by exchange, 1965                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
321038 1975.1.66 1 1 459007 Robert Lehman Collection 16 Painting 69 The Nativity           Artist 2   Lorenzo Monaco (Piero di Giovanni) Italian, Florence (?) ca. 1370–1425 Florence (?)   Lorenzo Monaco (Piero di Giovanni) 19023 Italian 6 1370 1425 ca. 1406–10 1403 1413 Tempera on wood, gold ground 44477 8 3/4 x 12 1/4 in. (22.2 x 31.1 cm) Robert Lehman Collection, 1975                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
321039 1975.1.67 0 1 459008 Robert Lehman Collection 16 Painting 69 The Crucified Christ between the Virgin and Saint John the Evangelist           Artist 2   Lorenzo Monaco (Piero di Giovanni) Italian, Florence (?) ca. 1370–1425 Florence (?)   Lorenzo Monaco (Piero di Giovanni) 19023 Italian 6 1370 1425 ca. 1406 1403 1409 Tempera on wood, gold ground 44477 Overall, including gable, 33 5/8 x 14 1/2 in. (85.4 x 36.8 cm) Robert Lehman Collection, 1975                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
321265 1975.1.335 1 1 459234 Robert Lehman Collection 16 Drawing 23 Three Virtues (Temperance, Hope, and Fortitude or Justice) and Studies of a Seated Man Italian, Florence 1136         Artist 2 Circle of Lorenzo Monaco (Piero di Giovanni) Italian, Florence (?) ca. 1370–1425 Florence (?)   Lorenzo Monaco (Piero di Giovanni) 19023 Italian 6 1370 1425 ca. 1420 1417 1423 Metalpoint, touches of brush and brown wash, heightened with white (partially oxidized in the figure at the lower left), on reddish violet prepared paper. Some lines retraced in pen and brown ink at a later date. 47820 9 13/16 x 7 5/16 in. (24.9 x 18.5 cm) Robert Lehman Collection, 1975                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
322955 1975.1.2485 0 1 461128 Robert Lehman Collection 16 Cutting from an antiphonary 14583 Last Judgment in an Initial C           Artist 2   Lorenzo Monaco (Piero di Giovanni) Italian, Florence (?) ca. 1370–1425 Florence (?)   Lorenzo Monaco (Piero di Giovanni) 19023 Italian 6 1370 1425 ca. 1406–7 1403 1410 Tempera and gold on parchment 47797 12 5/16 x 10 3/8 in. (31.3 x 26.4cm) Initial ground: 7 13/16 x 7 13/16 in. (19.9 x 19.8cm) Stave: 1 15/16 in. (5cm) Robert Lehman Collection, 1975                       Manuscripts and Illuminations 162   Metropolitan Museum of Art, New York, NY 1
328672 53.37 0 1 470328 The Cloisters 17 Painting 69 The Intercession of Christ and the Virgin Italian 36         Artist 2 Attributed to Lorenzo Monaco (Piero di Giovanni) Italian, Florence (?) ca. 1370–1425 Florence (?)   Lorenzo Monaco (Piero di Giovanni) 19023 Italian 6 1370 1425 before 1402 1402 1402 Tempera on canvas 44596 Overall: 94 1/4 x 60 1/4 x 1 in. (239.4 x 153 x 2.5 cm) The Cloisters Collection, 1953 Made in 1 Florence 562   Tuscany 119 Italy 14             Paintings-Canvas 868   Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 118.068ms · Data license: CC0 · Data source: metmuseum/openaccess